Office software is closely linked to the PDF,the PDF is also must have to control!
Set home Page Add to Favorites
|
1, cited the role of Quoted in the role of Excel logo is on the worksheet cell or range of cells, and the formula specified in the data used in the position. By reference, can be used in the formula for the different parts of the worksheet data, or formula in a number of cells using the same values. Workbook also invoke the same table in different cells, different cells of the workbook, or other data applications. 2, quoted in the meaning of Quoted as follows on the need to understand the meaning of several situations: External Reference - a different workbook in a cell known as the external reference citations. Remote references - to quote the data in other programs as the remote reference. Relative reference - in the creation of formula, or range of cells is often quoted in relation to the formula contained in the relative positions of the cell. Absolute reference - copy the formula in Excel do not want to adjust the reference, then use the absolute reference. That is, by adding a dollar sign, such as $ C $ 1. 3, that the methods cited There are two reports regarding the use of that method, that is, A1 and R1C1 reference style. (1) a reference style (default) - A1 A1 style reference is the default reference type Excel. Signs of this type out reference letters (from A to IV, a total of 256) and the number of marked lines (from 1-65536). These letters and numbers, known as the title rows and columns. If you want to reference cell, please enter the order set out the number of letters and lines. For example, C25 refers to column C and line 25 intersecting the cell. If you want to reference range, enter the regional upper-left corner of the reference cell, a colon (:) and regional reference to the lower right corner of the cell, such as A20: C35. (2) cited two styles - R1C1 In the R1C1 reference style in, Excel use the "R" plus line numbers and "C" to add the number to indicate the location of the cell. For example, the absolute cell reference R1C1 with A1 style references in the absolute reference $ A $ 1 equivalent. If the active cell is A1, while the relative cell reference R [1] C [1] will quote the following line and the right of a cell, or B2. After understanding the concept of reference, we take a look at Excel to provide the query and reference function. Query function can be used with the reference list or in the data table to find a specific value, or the need to find a reference cell. Excel has provided a total of ADDRESS, AREAS, CHOOSE, COLUMN, COLUMNS, HLOOKUP, HYPERLINK, INDEX, INDIRECT, LOOKUP, MATCH, OFFSET, ROW, ROWS, TRANSPOSE, VLOOKUP 16 inquiries and quote function. Now, I will introduce the division of these functions and simple to use application. |
